﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 上传文件管理实体类：fanli_uploadfile 。
	/// </summary>
	[Serializable]
	public class fanli_uploadfile
	{
		public fanli_uploadfile()
		{}

		#region Model
		private int _id; //id
		private string _cata; //类型
		private string _filepath; //路径
		private int _filesize; //大小
		private DateTime? _uploadDate; //日期
		private int _adminID; //操作人
		private string _ip; //操作ip
		private int _isQuote; //是否已引用


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 类型
		/// </summary>
		public string cata
		{
			set{ _cata=value;}
			get{return _cata;}
		}
        /// <summary>
		/// 路径
		/// </summary>
		public string filepath
		{
			set{ _filepath=value;}
			get{return _filepath;}
		}
        /// <summary>
		/// 大小
		/// </summary>
		public int filesize
		{
			set{ _filesize=value;}
			get{return _filesize;}
		}
        /// <summary>
		/// 日期
		/// </summary>
		public DateTime? uploadDate
		{
			set{ _uploadDate=value;}
			get{return _uploadDate;}
		}
        /// <summary>
		/// 操作人
		/// </summary>
		public int adminID
		{
			set{ _adminID=value;}
			get{return _adminID;}
		}
        /// <summary>
		/// 操作ip
		/// </summary>
		public string ip
		{
			set{ _ip=value;}
			get{return _ip;}
		}
        /// <summary>
		/// 是否已引用
		/// </summary>
		public int isQuote
		{
			set{ _isQuote=value;}
			get{return _isQuote;}
		}
		#endregion Model

		#region txt document
		/*
上传文件管理,uploadfile
id,类型,路径,大小,日期,操作人,操作ip,是否已引用
id,cata,filepath,filesize,uploadDate,adminID,ip,isQuote
i,c20,c256,i,d,i,c20,i

--------------------------
-- 创建表[上传文件管理]开始: 
-- alter table  [fanli_uploadfile] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_uploadfile') drop table fanli_uploadfile
  CREATE TABLE [fanli_uploadfile] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [cata] [varchar] (20),
	 [filepath] [varchar] (256),
	 [filesize] int,
	 [uploadDate] [datetime],
	 [adminID] int,
	 [ip] [varchar] (20),
	 [isQuote] int
  )

 exec sp_addextendedproperty N'MS_Description',N'上传文件管理 ',N'user',N'dbo',N'table',N'fanli_uploadfile', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_uploadfile',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'类型',N'user',N'dbo',N'table',N'fanli_uploadfile',N'column',N'cata'
 exec sp_addextendedproperty N'MS_Description',N'路径',N'user',N'dbo',N'table',N'fanli_uploadfile',N'column',N'filepath'
 exec sp_addextendedproperty N'MS_Description',N'大小',N'user',N'dbo',N'table',N'fanli_uploadfile',N'column',N'filesize'
 exec sp_addextendedproperty N'MS_Description',N'日期',N'user',N'dbo',N'table',N'fanli_uploadfile',N'column',N'uploadDate'
 exec sp_addextendedproperty N'MS_Description',N'操作人',N'user',N'dbo',N'table',N'fanli_uploadfile',N'column',N'adminID'
 exec sp_addextendedproperty N'MS_Description',N'操作ip',N'user',N'dbo',N'table',N'fanli_uploadfile',N'column',N'ip'
 exec sp_addextendedproperty N'MS_Description',N'是否已引用',N'user',N'dbo',N'table',N'fanli_uploadfile',N'column',N'isQuote'

-- 创建表[上传文件管理]结束。 
--------------------------

		*/
		#endregion document
	}
}

